/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/jtp_gd06_warehouse?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_new_product_price \
--export-dir /user/hive/warehouse/jtp_gd06_warehouse/ads_new_product_price \
--update-mode allowinsert \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1

/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/jtp_gd06_warehouse?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_new_product_monitoring \
--export-dir /user/hive/warehouse/jtp_gd06_warehouse/ads_new_product_monitoring \
--update-mode allowinsert \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1

/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/jtp_gd06_warehouse?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_review_product_year \
--export-dir /user/hive/warehouse/jtp_gd06_warehouse/ads_review_product_year \
--update-mode allowinsert \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1

/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/jtp_gd06_warehouse?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_new_product_list \
--export-dir /user/hive/warehouse/jtp_gd06_warehouse/ads_new_product_list \
--update-mode allowinsert \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1